/*
 Navicat Premium Data Transfer

 Source Server         : LocalSQLServer
 Source Server Type    : SQL Server
 Source Server Version : 16001000
 Source Host           : LAPTOP-6PNDDSDM:1433
 Source Catalog        : CampusMedical
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001000
 File Encoding         : 65001

 Date: 13/05/2024 21:50:13
*/


-- ----------------------------
-- Table structure for tb_appointment
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_appointment]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_appointment]
GO

CREATE TABLE [dbo].[tb_appointment] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [pt_id] bigint NOT NULL,
  [dr_id] bigint NOT NULL,
  [time] date DEFAULT (getdate()) NOT NULL,
  [stage] int NOT NULL,
  [status] int NOT NULL,
  [amount] numeric(8,2) NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_appointment] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_appointment',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'病人id',
'SCHEMA', N'dbo',
'TABLE', N'tb_appointment',
'COLUMN', N'pt_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'医生id',
'SCHEMA', N'dbo',
'TABLE', N'tb_appointment',
'COLUMN', N'dr_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'预计就诊时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_appointment',
'COLUMN', N'time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'预计就诊时间段',
'SCHEMA', N'dbo',
'TABLE', N'tb_appointment',
'COLUMN', N'stage'
GO

EXEC sp_addextendedproperty
'MS_Description', N'待确认，确认，取消',
'SCHEMA', N'dbo',
'TABLE', N'tb_appointment',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'挂号费用',
'SCHEMA', N'dbo',
'TABLE', N'tb_appointment',
'COLUMN', N'amount'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_appointment',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_appointment',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_appointment',
'COLUMN', N'utime'
GO


-- ----------------------------
-- Records of [tb_appointment]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_appointment] ON
GO

INSERT INTO [dbo].[tb_appointment] ([id], [pt_id], [dr_id], [time], [stage], [status], [amount], [deleted], [ctime], [utime]) VALUES (N'1', N'1', N'4', N'2024-04-16', N'0', N'-1', NULL, N'0', N'2024-02-25 14:21:17.177', N'2024-02-25 14:21:17.177')
GO

INSERT INTO [dbo].[tb_appointment] ([id], [pt_id], [dr_id], [time], [stage], [status], [amount], [deleted], [ctime], [utime]) VALUES (N'2', N'1', N'4', N'2024-04-17', N'0', N'-1', NULL, N'0', N'2024-02-26 15:55:51.857', N'2024-02-26 15:55:51.857')
GO

INSERT INTO [dbo].[tb_appointment] ([id], [pt_id], [dr_id], [time], [stage], [status], [amount], [deleted], [ctime], [utime]) VALUES (N'3', N'1', N'4', N'2024-04-17', N'0', N'-1', NULL, N'0', N'2024-03-24 23:29:57.693', N'2024-03-24 23:29:57.693')
GO

INSERT INTO [dbo].[tb_appointment] ([id], [pt_id], [dr_id], [time], [stage], [status], [amount], [deleted], [ctime], [utime]) VALUES (N'4', N'1', N'4', N'2024-04-18', N'0', N'-1', NULL, N'0', N'2024-04-15 21:28:25.010', N'2024-04-15 21:28:25.010')
GO

INSERT INTO [dbo].[tb_appointment] ([id], [pt_id], [dr_id], [time], [stage], [status], [amount], [deleted], [ctime], [utime]) VALUES (N'5', N'1', N'6', N'2024-04-19', N'0', N'-1', NULL, N'0', N'2024-04-19 16:25:46.247', N'2024-04-19 16:25:46.247')
GO

INSERT INTO [dbo].[tb_appointment] ([id], [pt_id], [dr_id], [time], [stage], [status], [amount], [deleted], [ctime], [utime]) VALUES (N'6', N'1', N'6', N'2024-04-19', N'0', N'-1', NULL, N'0', N'2024-04-19 16:40:47.210', N'2024-04-19 16:40:47.210')
GO

INSERT INTO [dbo].[tb_appointment] ([id], [pt_id], [dr_id], [time], [stage], [status], [amount], [deleted], [ctime], [utime]) VALUES (N'7', N'1', N'7', N'2024-04-20', N'0', N'-1', NULL, N'0', N'2024-04-20 09:18:11.200', N'2024-04-20 09:18:11.200')
GO

SET IDENTITY_INSERT [dbo].[tb_appointment] OFF
GO


-- ----------------------------
-- Table structure for tb_chat
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_chat]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_chat]
GO

CREATE TABLE [dbo].[tb_chat] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [from_id] bigint NOT NULL,
  [to_id] bigint NOT NULL,
  [content] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [time] datetime DEFAULT (getdate()) NOT NULL,
  [seen] int DEFAULT ((0)) NOT NULL,
  [deleted] int DEFAULT ((0)) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_chat] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_chat',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'发送人id',
'SCHEMA', N'dbo',
'TABLE', N'tb_chat',
'COLUMN', N'from_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'接收人id',
'SCHEMA', N'dbo',
'TABLE', N'tb_chat',
'COLUMN', N'to_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'内容',
'SCHEMA', N'dbo',
'TABLE', N'tb_chat',
'COLUMN', N'content'
GO

EXEC sp_addextendedproperty
'MS_Description', N'发送时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_chat',
'COLUMN', N'time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否已读标识',
'SCHEMA', N'dbo',
'TABLE', N'tb_chat',
'COLUMN', N'seen'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否删除标识',
'SCHEMA', N'dbo',
'TABLE', N'tb_chat',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'聊天信息表',
'SCHEMA', N'dbo',
'TABLE', N'tb_chat'
GO


-- ----------------------------
-- Records of [tb_chat]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_chat] ON
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'1', N'1', N'4', N'123', N'2024-02-24 21:22:51.210', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'2', N'1', N'4', N'321', N'2024-02-24 21:58:23.660', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'3', N'1', N'4', N'test', N'2024-02-25 15:15:57.080', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'4', N'1', N'4', N'test123', N'2024-02-25 15:17:55.337', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'5', N'4', N'1', N'response', N'2024-02-25 23:47:42.800', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'6', N'1', N'4', N'今天不舒服', N'2024-03-24 23:28:47.437', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'7', N'4', N'1', N'具体说说', N'2024-03-24 23:29:03.670', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'8', N'1', N'6', N'医生，您好', N'2024-04-19 16:24:31.403', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'9', N'6', N'1', N'你好，请问有什么问题', N'2024-04-19 16:24:51.250', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'10', N'1', N'6', N'肚子有点不舒服', N'2024-04-19 16:25:03.623', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'11', N'6', N'1', N'可以到校医院进行详细的交流', N'2024-04-19 16:25:16.487', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'12', N'1', N'7', N'医生，您好', N'2024-04-20 09:17:12.670', N'1', N'0')
GO

INSERT INTO [dbo].[tb_chat] ([id], [from_id], [to_id], [content], [time], [seen], [deleted]) VALUES (N'13', N'7', N'1', N'你好，是哪里不舒服吗', N'2024-04-20 09:17:29.517', N'1', N'0')
GO

SET IDENTITY_INSERT [dbo].[tb_chat] OFF
GO


-- ----------------------------
-- Table structure for tb_config
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_config]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_config]
GO

CREATE TABLE [dbo].[tb_config] (
  [id] int IDENTITY(1,1) NOT NULL,
  [title] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [value] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [code] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [parent] varchar(50) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[tb_config] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [tb_config]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_config] ON
GO

INSERT INTO [dbo].[tb_config] ([id], [title], [value], [code], [parent]) VALUES (N'1', N'windows系统储存文件夹', N'D:\peng_YuJun\JavaWeb\project-resoures\campus-medical', N'config0001', N'-1')
GO

INSERT INTO [dbo].[tb_config] ([id], [title], [value], [code], [parent]) VALUES (N'2', N'windows系统头像存储', N'\img\avatar', N'config00010002', N'config0001')
GO

INSERT INTO [dbo].[tb_config] ([id], [title], [value], [code], [parent]) VALUES (N'3', N'windows单位图片储存', N'\img\entPhotos', N'config00010003', N'config0001')
GO

INSERT INTO [dbo].[tb_config] ([id], [title], [value], [code], [parent]) VALUES (N'4', N'windows文章封面储存', N'\img\essayCovers', N'config00010004', N'config0001')
GO

INSERT INTO [dbo].[tb_config] ([id], [title], [value], [code], [parent]) VALUES (N'5', N'windows文章内容储存', N'\txt\essay', N'config00010005', N'config0001')
GO

INSERT INTO [dbo].[tb_config] ([id], [title], [value], [code], [parent]) VALUES (N'6', N'windows文章图片储存', N'\img\essayPics', N'config00010006', N'config0001')
GO

INSERT INTO [dbo].[tb_config] ([id], [title], [value], [code], [parent]) VALUES (N'7', N'windows小程序图片储存', N'\img\miniApp', N'config00010007', N'config0001')
GO

INSERT INTO [dbo].[tb_config] ([id], [title], [value], [code], [parent]) VALUES (N'8', N'windows医生签名图储存', N'\img\drSign', N'config00010008', N'config0001')
GO

SET IDENTITY_INSERT [dbo].[tb_config] OFF
GO


-- ----------------------------
-- Table structure for tb_diagnosis
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_diagnosis]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_diagnosis]
GO

CREATE TABLE [dbo].[tb_diagnosis] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [apmt_id] bigint NOT NULL,
  [pt_id] bigint NOT NULL,
  [dr_id] bigint NOT NULL,
  [symptoms] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [diagnosis] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [status] int NOT NULL,
  [signature] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [evaluation] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL,
  [stars] int NULL
)
GO

ALTER TABLE [dbo].[tb_diagnosis] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'预约id',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'apmt_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'病人id',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'pt_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'医生id',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'dr_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'症状',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'symptoms'
GO

EXEC sp_addextendedproperty
'MS_Description', N'诊断结果',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'diagnosis'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'签名链接',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'signature'
GO

EXEC sp_addextendedproperty
'MS_Description', N'评价',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'evaluation'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'utime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'评价打分',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis',
'COLUMN', N'stars'
GO

EXEC sp_addextendedproperty
'MS_Description', N'诊断信息表',
'SCHEMA', N'dbo',
'TABLE', N'tb_diagnosis'
GO


-- ----------------------------
-- Records of [tb_diagnosis]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_diagnosis] ON
GO

INSERT INTO [dbo].[tb_diagnosis] ([id], [apmt_id], [pt_id], [dr_id], [symptoms], [diagnosis], [status], [signature], [evaluation], [deleted], [ctime], [utime], [stars]) VALUES (N'2', N'1', N'1', N'4', N'1,2', N'静脉曲张，血管微堵', N'1', N'/res/img/sign/4.jpg', N'这个信息医疗服务真的方便快捷', N'0', N'2024-04-16 12:37:21.000', N'2024-02-26 02:37:21.220', N'4')
GO

INSERT INTO [dbo].[tb_diagnosis] ([id], [apmt_id], [pt_id], [dr_id], [symptoms], [diagnosis], [status], [signature], [evaluation], [deleted], [ctime], [utime], [stars]) VALUES (N'3', N'2', N'1', N'4', N'2,5', N'发热，感冒', N'1', N'/res/img/sign/4.jpg', N'医生说话冷冰冰的', N'0', N'2024-04-17 15:55:51.000', N'2024-02-26 15:55:51.897', N'1')
GO

INSERT INTO [dbo].[tb_diagnosis] ([id], [apmt_id], [pt_id], [dr_id], [symptoms], [diagnosis], [status], [signature], [evaluation], [deleted], [ctime], [utime], [stars]) VALUES (N'4', N'3', N'1', N'4', N'1', N'发热，口干', N'1', N'/res/img/sign/4.jpg', N'医生很好，很nice', N'0', N'2024-04-17 20:32:00.000', N'2024-03-24 23:32:00.440', N'4')
GO

INSERT INTO [dbo].[tb_diagnosis] ([id], [apmt_id], [pt_id], [dr_id], [symptoms], [diagnosis], [status], [signature], [evaluation], [deleted], [ctime], [utime], [stars]) VALUES (N'5', N'4', N'1', N'4', N'2', N'上火，燥热，口干', N'1', N'/res/img/drSign/2B203AA1-A8BB-457E-3497-11D1D400E729.png', N'这位医生很好，很会照顾患者情绪！', N'0', N'2024-04-18 12:29:23.000', N'2024-04-15 21:29:23.200', N'3')
GO

INSERT INTO [dbo].[tb_diagnosis] ([id], [apmt_id], [pt_id], [dr_id], [symptoms], [diagnosis], [status], [signature], [evaluation], [deleted], [ctime], [utime], [stars]) VALUES (N'6', N'5', N'1', N'6', N'3', N'感冒引发的腹泻', N'1', N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'医生很好，下次肚子痛还来找她', N'0', N'2024-04-19 16:27:27.320', N'2024-04-19 16:27:27.320', N'4')
GO

INSERT INTO [dbo].[tb_diagnosis] ([id], [apmt_id], [pt_id], [dr_id], [symptoms], [diagnosis], [status], [signature], [evaluation], [deleted], [ctime], [utime], [stars]) VALUES (N'7', N'7', N'1', N'7', N'3', N'感冒引发的腹泻', N'1', N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'很满意', N'0', N'2024-04-20 09:19:53.567', N'2024-04-20 09:19:53.567', N'4')
GO

SET IDENTITY_INSERT [dbo].[tb_diagnosis] OFF
GO


-- ----------------------------
-- Table structure for tb_disease
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_disease]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_disease]
GO

CREATE TABLE [dbo].[tb_disease] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [title] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [intro] nvarchar(max) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL,
  [priority] int DEFAULT ((1)) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_disease] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_disease',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标题',
'SCHEMA', N'dbo',
'TABLE', N'tb_disease',
'COLUMN', N'title'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'tb_disease',
'COLUMN', N'intro'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_disease',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_disease',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_disease',
'COLUMN', N'utime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'倒序排序',
'SCHEMA', N'dbo',
'TABLE', N'tb_disease',
'COLUMN', N'priority'
GO

EXEC sp_addextendedproperty
'MS_Description', N'疾病信息表',
'SCHEMA', N'dbo',
'TABLE', N'tb_disease'
GO


-- ----------------------------
-- Records of [tb_disease]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_disease] ON
GO

INSERT INTO [dbo].[tb_disease] ([id], [title], [intro], [deleted], [ctime], [utime], [priority]) VALUES (N'1', N'感冒', N'感冒(commoncold)又称伤风、冒风，是风邪侵袭人体所致的常见外感疾病。临床表现以鼻塞、咳嗽、头痛、恶寒发热、全身不适为其特征。全年均可发病，尤以春季多见。由于感邪之不同、体质强弱不一，证候可表现西医学的上呼吸道感染属中医的感冒范畴。西医学认为当人体受凉、淋雨、过度疲劳等诱发因素,使全身或呼吸道局部防御功能降低时，则原已存在于呼吸道的或从外界侵入的病毒、细菌可迅速繁殖，引起本病，以鼻咽部炎症为主要表现。引起普通感冒的主要为鼻病毒。\r\n\r\n', N'0', N'2024-02-26 01:24:45.907', N'2024-02-26 01:24:45.907', N'1')
GO

INSERT INTO [dbo].[tb_disease] ([id], [title], [intro], [deleted], [ctime], [utime], [priority]) VALUES (N'2', N'口腔溃疡', N'口腔溃疡，民间又称为“口疮”“上火”，是发生在口腔粘膜上的表浅性溃疡，大小可从米粒至黄豆大小、成圆形或卵圆形，溃疡面为凹、周围充血，可因刺激性食物引发疼痛，一般一 溃疡面为凹、周围充血，可因刺激性食物引发疼痛，一般一至两个星期可以自愈。口腔溃疡成周期性反复发生，医学上称\"复发性口腔溃疡\"(recurrent oral ulcer，ROU)、复发性阿弗他性口炎(recurrent aphthous stomatitis，RAS)、复发性口疮(recurrent aphthae)或canker sores。可一年发病数次，也可以一个月发病几次，甚至新旧病变交替出现。', N'0', N'2024-02-26 01:24:45.907', N'2024-02-26 01:24:45.907', N'1')
GO

INSERT INTO [dbo].[tb_disease] ([id], [title], [intro], [deleted], [ctime], [utime], [priority]) VALUES (N'3', N'腹泻', N'腹泻指排便次数增多，粪质稀薄，或带有粘液、脓血或未消化的食物。如解液状便，每日三次以上，或每日粪便总量大于200 g，其中粪便含水量大于80％，则可认为是腹泻。根据病程腹泻可分为急性腹泻和慢性腹泻。病程少于2个月者为急性腹泻。慢性腹泻4周内的复发性腹泻。腹泻常伴有排便急迫感、肛周不适、便失禁等症状。', N'0', N'2024-02-26 01:24:45.910', N'2024-02-26 01:24:45.910', N'1')
GO

INSERT INTO [dbo].[tb_disease] ([id], [title], [intro], [deleted], [ctime], [utime], [priority]) VALUES (N'4', N'头晕', N'  头晕是一种常见的脑部功能性障碍，也是临床常见的症状之一。表现为头昏、头胀、头重脚轻、脑内摇晃、眼花等的感觉。头晕可由多种原因引起，最常见于发热性疾病、高血压病、脑动脉硬化、颅脑外伤综合症、神经症等。此外，还见于贫血、心律失常、心力衰竭、低血压、药物中毒、尿毒症、哮喘等。抑郁症早期也常有头晕。头晕可单独出现，但常与头痛并发。头晕伴有平衡觉障碍或空间觉定向障碍时，患者感到外周环境或自身在旋转、移动或摇晃，称为头晕。', N'0', N'2024-02-26 01:24:45.910', N'2024-02-26 01:24:45.910', N'1')
GO

INSERT INTO [dbo].[tb_disease] ([id], [title], [intro], [deleted], [ctime], [utime], [priority]) VALUES (N'5', N'前列腺炎', N'　前列腺炎是指前列腺特异性和非特异感染所致的急慢性炎症，从而引起的全身或局部症状。前列腺炎可分为非特异性细菌性前列腺炎、特发性细菌性前列腺炎(又称前列腺病)、特异性前列腺炎(由淋球菌、结核菌、真菌、寄生虫等引起)、非特异性肉芽肿性前列腺炎、其它病原体(如病毒、支原体、衣原体等)引起的前列腺炎、前列腺充血和前列腺痛。', N'0', N'2024-02-26 01:24:45.910', N'2024-02-26 01:24:45.910', N'1')
GO

INSERT INTO [dbo].[tb_disease] ([id], [title], [intro], [deleted], [ctime], [utime], [priority]) VALUES (N'6', N'头外伤', N'头皮裂伤多由锐器或钝器致伤。裂口大小，深度不一，创缘整齐或不整齐，有时伴有皮肤挫伤或缺损，由于头皮血管丰富，血管破裂后不易自行闭合，即使伤口小出血也较严重，甚至因此发生休克。', N'0', N'2024-02-26 01:24:45.913', N'2024-02-26 01:24:45.913', N'1')
GO

INSERT INTO [dbo].[tb_disease] ([id], [title], [intro], [deleted], [ctime], [utime], [priority]) VALUES (N'7', N'创伤性鼻出血', N'创伤性鼻出血是因各种外力因素引起的鼻出血，是一种常见的鼻部疾病。', N'0', N'2024-02-26 01:24:45.913', N'2024-02-26 01:24:45.913', N'1')
GO

INSERT INTO [dbo].[tb_disease] ([id], [title], [intro], [deleted], [ctime], [utime], [priority]) VALUES (N'8', N'骨折', N'骨折系指由于外伤或病理等原因致使骨质部分地或完全地断裂的一种疾病。其主要临床表现为：骨折部有局限性疼痛和压痛，局部肿胀和出现瘀斑，肢体功能部位或完全丧失，完全性骨质尚可出现肢体畸形及异常活动。', N'0', N'2024-02-26 01:24:45.913', N'2024-02-26 01:24:45.913', N'1')
GO

INSERT INTO [dbo].[tb_disease] ([id], [title], [intro], [deleted], [ctime], [utime], [priority]) VALUES (N'9', N'风湿热', N'风湿热(rheumatic fever)是一种常见的反复发作的急性或慢性身性结缔组织炎症，主要累及心脏、关节、中枢神经系统、皮肤和皮下组织。临床表现以心脏炎和关节炎为主，可伴有发热、毒血症、皮疹、皮下小结、舞蹈病等。它通常发生于链球菌感染后2～4周，是一种对咽部A组溶血性链球菌感染的变态反应性疾病。急性发作时通常以关节炎较为明显，但在此阶段风湿性心脏炎可造成病人死亡。急性发作后常遗留轻重不等的心脏损害。', N'0', N'2024-02-26 01:24:45.917', N'2024-02-26 01:24:45.917', N'1')
GO

SET IDENTITY_INSERT [dbo].[tb_disease] OFF
GO


-- ----------------------------
-- Table structure for tb_doctor
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_doctor]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_doctor]
GO

CREATE TABLE [dbo].[tb_doctor] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [uid] bigint NULL,
  [code] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [phone] varchar(11) COLLATE Chinese_PRC_CI_AS NULL,
  [name] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [ent_code] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [photos] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [rank] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
  [expert] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [experience] varchar(3000) COLLATE Chinese_PRC_CI_AS NULL,
  [sign] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_doctor] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'医生关联的用户id',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'uid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'医生编号',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'手机号',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'phone'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名称',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'所属科室编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'ent_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'图片链接，逗号间隔',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'photos'
GO

EXEC sp_addextendedproperty
'MS_Description', N'职称',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'rank'
GO

EXEC sp_addextendedproperty
'MS_Description', N'擅长内容',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'expert'
GO

EXEC sp_addextendedproperty
'MS_Description', N'过往经验',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'experience'
GO

EXEC sp_addextendedproperty
'MS_Description', N'签名链接',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'sign'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_doctor',
'COLUMN', N'utime'
GO


-- ----------------------------
-- Records of [tb_doctor]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_doctor] ON
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'1', N'4', N'dr0004', N'14538783820', N'杨阳', N'ent00030004', NULL, N'副主任医师', N'射频消融治疗快速心律失常；介入心脏病学及高血压的防治工作', N'曾于2018年，被授予“国之名医”荣誉称号。', N'/res/img/drSign/2B203AA1-A8BB-457E-3497-11D1D400E729.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'2', N'5', N'dr0005', N'17683484143', N'张绍文', N'ent00030004', NULL, N'副主任医师', N'诊治心血管内科相关疾病', N'张绍文，男，主任医师，教授，博士生导师，1964-10-21，医学博士，现任同济大学医学院副院长、同济大学医学遗传研究所所长、心律失常教育部重点实验室主任，国家杰出青年科学基金项目获得者，教育部长江学者特聘教授。专业特长：心房颤动和高血压病的诊断和治疗。主要研究方向：心律失常的发生机制。先后主持十多项科研项目，其中包括国家杰出青年科学基金项目和国家自然科学基金重点项目等。在心律失常研究领域做出了杰出的贡献。先后发现了三个人类心房颤动致病基因；确立了心脏钾通道分子缺陷是心房颤动发生的部分分子基础；发现人类心房颤动的三个细胞电生理学机制。先后发表论文60多篇，标志性成果发表在《Science》和《Am J Hum Genet》等刊物上。获得国家自然科学奖二等奖（第一完成人）、教育部自然科学奖一等奖（第一完成人）、中国青年科技奖、卫生部有突出贡献的中青年专家、上海市十大科技精英、上海市优秀学科带头人、上海市医学领军人才和上海市劳动模范等荣誉或称号。《Circulation》、《JACC》、《Cardiovasc Res》和《Hum Genet》等刊物的审稿人。中国医学遗传学会委员、中国青年科技工作者协会委员、上海市遗传学会理事、上海市医学会医学遗传学会副主任委员、《中华医学遗传学杂志》、《中国分子心脏病学杂志》等杂志编委。', N'/res/img/drSign/7999A60B-630D-B76F-7A8D-51D8E9E598C2.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'3', N'6', N'dr0006', N'14606013829', N'倪群', N'ent00030005', NULL, N'副主任医师', N'早发及遗传性糖尿病的诊治 糖尿病干细胞治疗', N'副主任医师，博导。同济大学附属东方医院南院内分泌科执行主任兼干细胞基地办副主任。主攻线粒体糖尿病诊治及糖尿病干细胞治疗。', N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'4', N'7', N'dr0007', N'15277212611', N'黄宜', N'ent00030006', NULL, N'医师', N'对疑难消化疾病的诊治及危重病人的抢救；擅长肝病及胃肠疾病的诊治，在脂肪性肝病、肝硬化、炎症性肠病等疾病的诊疗积累了丰富的经验', N'黄宜，女，医师，教授，博士，博士生导师。同济大学附属东方医院本部消化内科科主任，中国医疗保健国际交流促进会消化病学分会第六届委员会委员，中华消化学会食管协作组委员、中华医学生物免疫学会首届学术委员会常务委员、中华医学会上海分会消化系病专科委员会委员、动力学组副组长，上海市消化内科临床质控中心专家委员会委员、第七届上海市中西医结合学会消化系统疾病专业委员会委员、上海消化医师学会顾问、国家自然基金会评议专家、上海市政府采购评审专家、上海市医学会医疗鉴定专家、上海市医学会医师规范化培训考官，北京医学奖励基金会炎症性肠病专家委员会委员、浦东新区消化病学专业委员会名誉主任委员等职。《World Journal of Gastroenterology 》、《国际消化病学杂志》、《上海医药》、《中华临床医师杂志》、《GUT》中文版食管分册等编委。承担国家自然科学基金项目、卫生部内科消化重点实验室、上海市自然科学基金、上海市卫生局和浦东新区科委等多项课题。获上海市科技成果一项和上海市医学科技三等奖一项。在国内外杂志发表研究论文50余篇，SCI文章多篇。主编专著《胃肠肝胆疾病与营养》、《消化内科学双语手册》和《消化系统疾病与营养导论》，参编当代医学院士经典系列《江绍基胃肠病学》等多部专著。', N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'5', N'8', N'dr0008', N'13044241475', N'詹晓玲', N'ent00030007', NULL, N'副主任医师', NULL, NULL, N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'6', N'9', N'dr0009', N'15500976461', N'沈建庆', N'ent00030008', NULL, N'主任医师', NULL, NULL, N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'7', N'10', N'dr0010', N'18623675937', N'郑海涛', N'ent00030008', NULL, N'医师', NULL, NULL, N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'8', N'11', N'dr0011', N'17763089961', N'陈立峰', N'ent00030009', NULL, N'副主任医师', NULL, NULL, N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'9', N'12', N'dr0012', N'17249383579', N'萧旒萍', N'ent00030010', NULL, N'副主任医师', NULL, NULL, N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'10', N'13', N'dr0013', N'13899237201', N'竺远', N'ent00030010', NULL, N'副主任医师', NULL, NULL, N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'11', N'14', N'dr0014', N'15178423861', N'肖瑾言', N'ent00030011', NULL, N'副主任医师', NULL, NULL, N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'12', N'15', N'dr0015', N'13192357695', N'胡苗', N'ent00030011', NULL, N'主治医师', NULL, NULL, N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

INSERT INTO [dbo].[tb_doctor] ([id], [uid], [code], [phone], [name], [ent_code], [photos], [rank], [expert], [experience], [sign], [deleted], [ctime], [utime]) VALUES (N'13', N'16', N'dr0016', N'13554126220', N'张迎春', N'ent00030013', NULL, N'副主任医师', NULL, NULL, N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-02-24 00:51:26.237', N'2024-02-24 00:51:26.237')
GO

SET IDENTITY_INSERT [dbo].[tb_doctor] OFF
GO


-- ----------------------------
-- Table structure for tb_enterprise
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_enterprise]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_enterprise]
GO

CREATE TABLE [dbo].[tb_enterprise] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [code] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [parent] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [title] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [intro] text COLLATE Chinese_PRC_CI_AS NULL,
  [location] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [photos] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [priority] int DEFAULT ((1)) NOT NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_enterprise] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'parent'
GO

EXEC sp_addextendedproperty
'MS_Description', N'组织名称',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'title'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'intro'
GO

EXEC sp_addextendedproperty
'MS_Description', N'位置',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'location'
GO

EXEC sp_addextendedproperty
'MS_Description', N'图片链接，先允许一张',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'photos'
GO

EXEC sp_addextendedproperty
'MS_Description', N'倒序排序 ',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'priority'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise',
'COLUMN', N'utime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'组织单位表',
'SCHEMA', N'dbo',
'TABLE', N'tb_enterprise'
GO


-- ----------------------------
-- Records of [tb_enterprise]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_enterprise] ON
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'3', N'ent0003', N'-1', N'校医室单位', N'校医室所辖单位', N'北二门进来右手边菠萝树处', N'/res/img/entPhotos/2CCFC831-F80D-E364-C5A4-B0D6279B52BF.webp', N'10', N'0', N'2024-01-28 02:31:04.707', N'2024-01-28 02:31:04.707')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'4', N'ent00030004', N'ent0003', N'心血管内科', N'心内科，即心血管内科，是各级医院大内科为了诊疗心血管疾病而设置的一个临床科室，治疗的疾病包括心绞痛、高血压、猝死、心律失常、心力衰竭、早搏、心律不齐、心肌梗死、心肌病、心肌炎、急性心肌梗死等心血管疾病。', N'校医室102', N'/res/img/entPhotos/CD8916E6-CC56-38E4-0387-E873799FCBD7.png', N'10', N'0', N'2024-01-28 14:12:33.417', N'2024-01-28 14:12:33.417')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'5', N'ent00030005', N'ent0003', N'内分泌科', N'内分泌科是医院中一个专门治疗内分泌科疾病的地方，主要负责糖尿病、肥胖症、骨质疏松、痛风、脂质代谢紊乱以及甲状腺、垂体、肾上腺、性腺、甲状旁腺等疾病的临床诊治。', N'校医室103', N'/res/img/entPhotos/24D76CE8-76C9-512D-69C7-FC284D6628D7.png', N'9', N'0', N'2024-01-28 14:45:36.373', N'2024-01-28 14:45:36.373')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'6', N'ent00030006', N'ent0003', N'消化内科', N'消化内科是研究食管、胃、小肠、大肠、肝、胆及胰腺等疾病为主要内容的临床三级学科。消化内科疾病种类繁多，医学知识面广，操作复杂而精细。', N'校医室104', N'/res/img/entPhotos/EBBD89FB-0FEA-E8F8-940E-00666DE6AF44.png', N'8', N'0', N'2024-01-28 14:46:05.060', N'2024-01-28 14:46:05.060')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'7', N'ent00030007', N'ent0003', N'神经内科', N'神经内科是关于神经方面的二级学科。不属于内科概念。主要收治脑血管疾病（脑梗塞、脑出血）、偏头痛、脑部炎症性疾病（脑炎、脑膜炎）、脊髓炎、癫痫、痴呆、代谢病和遗传倾向疾病、三叉神经痛、坐骨神经病、周围神经病及重症肌无力等。', N'校医室105', N'/res/img/entPhotos/30FD834E-1894-B505-9D09-811CA52E5295.png', N'7', N'0', N'2024-01-28 14:48:08.053', N'2024-01-28 14:48:08.053')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'8', N'ent00030008', N'ent0003', N'普外科', N'普外科(Department of general surgery)是以手术为主要方法治疗肝脏、胆道、胰腺、胃肠、肛肠、血管疾病、甲状腺和乳房的肿瘤及外伤等其它疾病的临床学科，是外科系统最大的专科。', N'校医室202', N'/res/img/entPhotos/2652CC69-BAEC-F66D-4666-A1BBA3BBBEC2.png', N'6', N'0', N'2024-01-28 14:49:01.143', N'2024-01-28 14:49:01.143')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'9', N'ent00030009', N'ent0003', N'骨科', N'骨科是各大医院最常见的科室之一，主要研究骨骼肌肉系统的解剖、生理与病理，运用药物、手术及物理方法保持和发展这一系统的正常形态与功能。', N'校医室204', N'/res/img/entPhotos/BDE1F2BF-0046-175A-E0D6-5DB2E27F81B3.png', N'5', N'0', N'2024-01-28 14:50:04.650', N'2024-01-28 14:50:04.650')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'10', N'ent00030010', N'ent0003', N'儿科', N'儿科是全面研究小儿时期身心发育、保健以及疾病防治的综合医学科学。凡涉及儿童和青少年时期的健康与卫生问题都属于儿科范围。其医治的对象处于生长发育期。', N'校医室205', N'/res/img/entPhotos/AD3AF540-AA9C-9556-4502-FBAF0CC69DB8.png', N'4', N'0', N'2024-01-28 14:50:57.707', N'2024-01-28 14:50:57.707')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'11', N'ent00030011', N'ent0003', N'口腔科', N'口腔科，医学学科分类之一。主要口腔科疾病包括：口腔颌面部皮样、表皮颌下间隙感染、颌面部淋巴管瘤、齿状突发育畸形、上颌窦恶性肿瘤、颌骨造釉细胞瘤、慢性筛窦炎、下颌后缩、四环素牙、舌白斑等疾病。', N'校医室203', N'/res/img/entPhotos/DD2C4BF9-595E-5678-A1C3-6E02FE37A493.png', N'3', N'0', N'2024-01-28 14:51:24.947', N'2024-01-28 14:51:24.947')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'13', N'ent00030013', N'ent0003', N'皮肤科', N'皮肤科属于外科，主要治疗各种皮肤病，常见皮肤病有牛皮癣 、 疱疹 、酒渣鼻 、脓疱疮 、化脓菌感染 、疤痕 、癣 、鱼鳞病 、腋臭 、青春痘 、毛囊炎 、斑秃脱发 、男科炎症 、婴儿尿布疹 、鸡眼 、雀斑 、汗疱疹 、螨虫性皮炎 、白癜风 、湿疹 、灰指甲 、硬皮病 、皮肤瘙痒 、口腔部护理 、脱毛 、黄褐斑等。', N'校医室201', N'/res/img/entPhotos/8BF719B7-3275-F36E-EF65-1F2FDD8D11A7.png', N'2', N'0', N'2024-01-28 14:53:22.663', N'2024-01-28 14:53:22.663')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'14', N'ent0014', N'-1', N'教学单位', N'负责教学的单位', N'岭南师范学院', N'undefined', N'9', N'0', N'2024-01-30 15:17:28.707', N'2024-01-30 15:17:28.707')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'15', N'ent00140015', N'ent0014', N'计算机与智能教育学院', N'一个专注于培养学生在计算机和人工智能领域的技术与教育能力的学院', N'综b', N'undefined', N'10', N'0', N'2024-01-30 15:19:24.143', N'2024-01-30 15:19:24.143')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'16', N'ent001400150016', N'ent00140015', N'软件工程', N'无', N'无', N'undefined', N'10', N'0', N'2024-01-30 15:20:28.843', N'2024-01-30 15:20:28.843')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'17', N'ent0014001500160017', N'ent001400150016', N'2020软件1班', N'无', N'无', N'undefined', N'10', N'0', N'2024-01-30 15:21:43.087', N'2024-01-30 15:21:43.087')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'18', N'ent0014001500160018', N'ent001400150016', N'2020软件2班', N'无', N'无', N'undefined', N'9', N'0', N'2024-01-30 15:22:22.853', N'2024-01-30 15:22:22.853')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'19', N'ent0014001500160019', N'ent001400150016', N'2020软件3班', N'无', N'无', N'undefined', N'8', N'0', N'2024-01-30 15:22:55.477', N'2024-01-30 15:22:55.477')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'20', N'ent0014001500160020', N'ent001400150016', N'2020软件4班', N'无', N'无', N'undefined', N'7', N'0', N'2024-01-30 15:20:28.843', N'2024-01-30 15:20:28.843')
GO

INSERT INTO [dbo].[tb_enterprise] ([id], [code], [parent], [title], [intro], [location], [photos], [priority], [deleted], [ctime], [utime]) VALUES (N'21', N'ent0021', N'-1', N'管理单位', N'', N'', N'', N'8', N'0', N'2024-04-17 19:08:54.223', N'2024-04-17 19:08:54.223')
GO

SET IDENTITY_INSERT [dbo].[tb_enterprise] OFF
GO


-- ----------------------------
-- Table structure for tb_essay
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_essay]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_essay]
GO

CREATE TABLE [dbo].[tb_essay] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [title] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [author] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [cover] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [intro] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [content] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [type] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [alarm] int DEFAULT ((0)) NOT NULL,
  [read_by] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [status] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_essay] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标题',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'title'
GO

EXEC sp_addextendedproperty
'MS_Description', N'作者名',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'author'
GO

EXEC sp_addextendedproperty
'MS_Description', N'封面',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'cover'
GO

EXEC sp_addextendedproperty
'MS_Description', N'简介',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'intro'
GO

EXEC sp_addextendedproperty
'MS_Description', N'内容',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'content'
GO

EXEC sp_addextendedproperty
'MS_Description', N'类型code，逗号分隔',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否需要通知',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'alarm'
GO

EXEC sp_addextendedproperty
'MS_Description', N'已读用户id，逗号分隔',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'read_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay',
'COLUMN', N'utime'
GO


-- ----------------------------
-- Records of [tb_essay]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_essay] ON
GO

INSERT INTO [dbo].[tb_essay] ([id], [title], [author], [cover], [intro], [content], [type], [alarm], [read_by], [status], [ctime], [utime]) VALUES (N'7', N'心理健康关怀', N'校医院', N'/res/img/essayCovers/ACF2A6FD-C531-6004-DBB6-6FD49C53E849.jpg', N'当你感到疲惫或焦虑时，可以尝试一些简单的自我护理方法来提升身心健康。以下是一些建议： 深呼吸：找一个安静的地方，闭上眼睛，深呼吸几次。吸气时，慢慢吸气并感觉肚子膨胀，然后慢慢呼气，', N'/res/txt/essay/921A3FE5-DB6A-7B1F-5CE8-0C137A584BF3.html', N'et0002,et00020009', N'0', NULL, N'2', N'2024-01-29 19:05:21.330', N'2024-04-20 09:24:46.277')
GO

INSERT INTO [dbo].[tb_essay] ([id], [title], [author], [cover], [intro], [content], [type], [alarm], [read_by], [status], [ctime], [utime]) VALUES (N'8', N'工作动态丨医校携手，共筑健康校园', N'校医院', N'/res/img/essayCovers/D4C3B1C3-1D9C-A27B-F2F4-3940F85BE581.jpeg', N'为做好校园卫生健康工作，卫生健康系统以多种形式开展疾病预防和健康服务保障工作，在科普宣传、疾病防控、医疗保障等工作中履职尽责，全力保障师生健康。', N'/res/txt/essay/70B66CC5-4AE1-9D8F-871C-A93D8C92A09C.html', N'et0002', N'0', NULL, N'2', N'2024-04-18 23:05:00.240', N'2024-04-18 23:05:00.240')
GO

SET IDENTITY_INSERT [dbo].[tb_essay] OFF
GO


-- ----------------------------
-- Table structure for tb_essay_type
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_essay_type]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_essay_type]
GO

CREATE TABLE [dbo].[tb_essay_type] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [code] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [parent] varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [title] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [intro] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [priority] int DEFAULT ((1)) NOT NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_essay_type] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay_type',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay_type',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay_type',
'COLUMN', N'parent'
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay_type',
'COLUMN', N'title'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay_type',
'COLUMN', N'intro'
GO

EXEC sp_addextendedproperty
'MS_Description', N'倒序排序 ',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay_type',
'COLUMN', N'priority'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay_type',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay_type',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay_type',
'COLUMN', N'utime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'文章类型表',
'SCHEMA', N'dbo',
'TABLE', N'tb_essay_type'
GO


-- ----------------------------
-- Records of [tb_essay_type]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_essay_type] ON
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'2', N'et0002', N'-1', N'健康知识', N'提供关于健康和疾病相关知识的资讯内容，以帮助用户更好地了解和管理自己的健康。', N'10', N'0', N'2024-01-28 17:39:11.537', N'2024-01-28 17:39:11.537')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'3', N'et0003', N'-1', N'心理健康', N'提供有关心理健康和情绪管理的资讯内容，帮助用户维持良好的心理状态和情绪平衡。', N'9', N'0', N'2024-01-28 17:43:23.383', N'2024-01-28 17:43:23.383')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'4', N'et0004', N'-1', N'生活习惯', N'提供有关促进健康生活习惯的资讯内容，包括饮食、运动和睡眠等方面的建议和指导。', N'8', N'0', N'2024-01-28 17:43:41.473', N'2024-01-28 17:43:41.473')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'5', N'et0005', N'-1', N'性健康', N'提供关于性教育、性健康和性行为方面的资讯内容，帮助用户获得健康的性生活。', N'7', N'0', N'2024-01-28 17:43:59.410', N'2024-01-28 17:43:59.410')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'6', N'et0006', N'-1', N'预防接种', N'提供有关疫苗接种和预防疾病的资讯内容，以促进健康的免疫系统和预防疾病的传播。', N'6', N'0', N'2024-01-28 17:45:57.483', N'2024-01-28 17:45:57.483')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'7', N'et00020007', N'et0002', N'常见疾病', N'了解常见疾病的症状、预防和治疗方法', N'10', N'0', N'2024-01-28 17:46:34.177', N'2024-01-28 17:46:34.177')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'8', N'et00020008', N'et0002', N'饮食健康', N'获取关于营养搭配、食物安全和饮食禁忌的建议和指导。', N'9', N'0', N'2024-01-28 17:47:00.420', N'2024-01-28 17:47:00.420')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'9', N'et00020009', N'et0002', N'睡眠养生', N'了解改善睡眠质量、建立健康的睡眠习惯和生活方式的知识。', N'8', N'0', N'2024-01-28 17:50:24.410', N'2024-01-28 17:50:24.410')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'10', N'et00030010', N'et0003', N'压力管理', N'学习有效的压力管理技巧，提高心理抗压能力。', N'10', N'0', N'2024-01-28 17:51:16.440', N'2024-01-28 17:51:16.440')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'11', N'et00030011', N'et0003', N'情绪调节', N'了解情绪管理和情绪健康的方法，培养积极情绪和心态。', N'9', N'0', N'2024-01-28 17:51:36.453', N'2024-01-28 17:51:36.453')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'12', N'et00030012', N'et0003', N'心理疾病介绍', N'获取关于常见心理疾病的信息，包括症状、诊断和治疗选项。', N'8', N'0', N'2024-01-28 17:51:57.480', N'2024-01-28 17:51:57.480')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'13', N'et00040013', N'et0004', N'锻炼健身', N'了解合适的锻炼方式、健身计划和身体健康的重要性。', N'10', N'0', N'2024-01-28 17:52:33.703', N'2024-01-28 17:52:33.703')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'14', N'et00040014', N'et0004', N'饮食习惯', N'学习良好的饮食习惯，了解均衡饮食和食物选择的重要性。', N'9', N'0', N'2024-01-28 17:53:06.240', N'2024-01-28 17:53:06.240')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'15', N'et00050015', N'et0005', N'性教育知识', N'获取关于性教育、性健康和性行为方面的知识和指导。', N'10', N'0', N'2024-01-28 17:53:35.373', N'2024-01-28 17:53:35.373')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'16', N'et00050016', N'et0005', N'避孕方法', N'了解安全有效的避孕方法，选择适合自己的避孕措施。', N'9', N'0', N'2024-01-28 17:53:57.143', N'2024-01-28 17:53:57.143')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'17', N'et00050017', N'et0005', N'性传播疾病预防', N'了解性传播疾病的预防措施和性健康检查的重要性。', N'8', N'0', N'2024-01-28 17:54:26.930', N'2024-01-28 17:54:26.930')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'18', N'et00060018', N'et0006', N'常见疫苗', N'了解不同疫苗的作用、接种程序以及预防疾病的重要性。', N'10', N'0', N'2024-01-28 17:55:01.773', N'2024-01-28 17:55:01.773')
GO

INSERT INTO [dbo].[tb_essay_type] ([id], [code], [parent], [title], [intro], [priority], [deleted], [ctime], [utime]) VALUES (N'19', N'et00060019', N'et0006', N'接种消息', N'向用户提供最新、准确和有用的接种信息，帮助用户了解疫苗接种的重要性、接种时间表、疫苗种类以及接种程序等方面的知识。', N'9', N'0', N'2024-01-28 17:55:54.023', N'2024-01-28 17:55:54.023')
GO

SET IDENTITY_INSERT [dbo].[tb_essay_type] OFF
GO


-- ----------------------------
-- Table structure for tb_medicine
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_medicine]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_medicine]
GO

CREATE TABLE [dbo].[tb_medicine] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [title] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [spec] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [useway] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [photos] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [price] numeric(8,2) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL,
  [priority] int DEFAULT ((1)) NOT NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [unit] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [rest] int DEFAULT ((0)) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_medicine] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标题',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'title'
GO

EXEC sp_addextendedproperty
'MS_Description', N'规格',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'spec'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用法',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'useway'
GO

EXEC sp_addextendedproperty
'MS_Description', N'图片链接，逗号间隔',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'photos'
GO

EXEC sp_addextendedproperty
'MS_Description', N'价格',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'price'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'utime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'倒序排序 ',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'priority'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单位',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'unit'
GO

EXEC sp_addextendedproperty
'MS_Description', N'货存',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine',
'COLUMN', N'rest'
GO

EXEC sp_addextendedproperty
'MS_Description', N'药物表',
'SCHEMA', N'dbo',
'TABLE', N'tb_medicine'
GO


-- ----------------------------
-- Records of [tb_medicine]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_medicine] ON
GO

INSERT INTO [dbo].[tb_medicine] ([id], [title], [spec], [useway], [photos], [price], [utime], [priority], [deleted], [ctime], [unit], [rest]) VALUES (N'1', N'感康（复方氨酚烷胺片）', N'0.4g*24片', N'餐前口服+一日3次+每次两粒', N'/res/img/medicine/感康.jpg', N'12.00', N'2024-02-26 01:12:20.613', N'1', N'0', N'2024-02-26 01:12:20.613', N'盒', N'0')
GO

INSERT INTO [dbo].[tb_medicine] ([id], [title], [spec], [useway], [photos], [price], [utime], [priority], [deleted], [ctime], [unit], [rest]) VALUES (N'2', N'金振口服液', N'0.2l*10支', N'餐前口服+一日2次+每次1支', N'/res/img/medicine/金振口服液.jpg', N'33.50', N'2024-02-26 01:12:20.617', N'1', N'0', N'2024-02-26 01:12:20.617', N'盒', N'0')
GO

INSERT INTO [dbo].[tb_medicine] ([id], [title], [spec], [useway], [photos], [price], [utime], [priority], [deleted], [ctime], [unit], [rest]) VALUES (N'3', N'脉通', N'0.25g*20片', N'口服+3次/日+每次两粒', N'/res/img/medicine/脉通.jpg', N'20.00', N'2024-02-26 01:12:20.617', N'1', N'0', N'2024-02-26 01:12:20.617', N'盒', N'0')
GO

INSERT INTO [dbo].[tb_medicine] ([id], [title], [spec], [useway], [photos], [price], [utime], [priority], [deleted], [ctime], [unit], [rest]) VALUES (N'4', N'奥美拉挫胶囊', N'0.4g*24片', N'口服+3次/日+每次两粒', N'/res/img/medicine/奥美拉挫胶囊.jpg', N'40.00', N'2024-02-26 01:12:20.620', N'1', N'0', N'2024-02-26 01:12:20.620', N'盒', N'0')
GO

INSERT INTO [dbo].[tb_medicine] ([id], [title], [spec], [useway], [photos], [price], [utime], [priority], [deleted], [ctime], [unit], [rest]) VALUES (N'5', N'阿莫西林', N'0.3g*24片', N'口服+3次/日+每次两粒', N'/res/img/medicine/阿莫西林.jpg', N'18.00', N'2024-02-26 01:12:20.620', N'1', N'0', N'2024-02-26 01:12:20.620', N'盒', N'0')
GO

SET IDENTITY_INSERT [dbo].[tb_medicine] OFF
GO


-- ----------------------------
-- Table structure for tb_menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_menu]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_menu]
GO

CREATE TABLE [dbo].[tb_menu] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [code] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [parent] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [title] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [url] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [icon] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [intro] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [preset] int DEFAULT ((0)) NOT NULL,
  [expand] int DEFAULT ((0)) NOT NULL,
  [priority] int DEFAULT ((1)) NOT NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_menu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'parent'
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'title'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单链接',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'图标',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'icon'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'intro'
GO

EXEC sp_addextendedproperty
'MS_Description', N'默认显示',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'preset'
GO

EXEC sp_addextendedproperty
'MS_Description', N'默认展开',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'expand'
GO

EXEC sp_addextendedproperty
'MS_Description', N'倒序排序 ',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'priority'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_menu',
'COLUMN', N'utime'
GO


-- ----------------------------
-- Records of [tb_menu]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_menu] ON
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'2', N'menu0002', N'-1', N'用户管理', N'ManageUser', N'el-icon-user-solid', N'用户表信息的增删改查', N'0', N'0', N'10', N'0', N'2024-01-27 16:59:34.557', N'2024-01-27 16:59:34.557')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'4', N'menu0004', N'-1', N'权限管理', N'ManageRule', N'el-icon-s-custom', N'角色表和角色菜单关联表的信息管理', N'0', N'0', N'9', N'0', N'2024-01-27 17:10:07.097', N'2024-01-27 17:10:07.097')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'5', N'menu0005', N'-1', N'菜单管理', N'ManageMenu', N'el-icon-menu', N'菜单信息表的增删改查', N'0', N'0', N'8', N'0', N'2024-01-27 17:11:57.133', N'2024-01-27 17:11:57.133')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'6', N'menu0006', N'-1', N'资讯管理', N'#', N'el-icon-notebook-2', N'管理资讯模块的内容', N'0', N'0', N'6', N'0', N'2024-01-27 19:21:04.190', N'2024-01-27 19:21:04.190')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'7', N'menu00060007', N'menu0006', N'类别管理', N'ManageEssayType', N'el-icon-edit', N'资讯类别表的增删改查', N'0', N'0', N'10', N'0', N'2024-01-27 19:23:51.000', N'2024-01-27 19:23:51.000')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'8', N'menu00060008', N'menu0006', N'资讯管理', N'ManageEssay', N'el-icon-edit', N'资讯信息表的增删改查', N'0', N'0', N'9', N'0', N'2024-01-27 19:25:25.523', N'2024-01-27 19:25:25.523')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'9', N'menu00060009', N'menu0006', N'资讯编写', N'BusWriteEssay', N'el-icon-edit', N'资讯内容的编写', N'0', N'0', N'8', N'0', N'2024-01-27 19:26:53.493', N'2024-01-27 19:26:53.493')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'10', N'menu0010', N'-1', N'单位管理', N'ManageEnt', N'el-icon-office-building', N'单位表的增删改查', N'0', N'0', N'7', N'0', N'2024-01-27 23:58:30.313', N'2024-01-27 23:58:30.313')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'11', N'menu0011', N'-1', N'药品管理', N'ManageMedi', N'el-icon-eleme', N'管理药品信息', N'0', N'0', N'5', N'0', N'2024-03-16 15:05:24.780', N'2024-03-16 15:05:24.780')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'12', N'menu0012', N'-1', N'疾病管理', N'ManageDisease', N'el-icon-eleme', N'管理疾病信息', N'0', N'0', N'4', N'0', N'2024-03-16 15:06:35.550', N'2024-03-16 15:06:35.550')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'13', N'menu0013', N'-1', N'医生管理', N'ManageDr', N'el-icon-user-solid', N'管理医生信息', N'0', N'0', N'10', N'0', N'2024-03-16 16:56:08.297', N'2024-03-16 16:56:08.297')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'10011', N'menu10011', N'-1', N'医生个人信息', N'ManageDrSelf', N'el-icon-user', N'设置个人信息', N'0', N'0', N'11', N'0', N'2024-04-02 17:38:19.663', N'2024-04-02 17:38:19.663')
GO

INSERT INTO [dbo].[tb_menu] ([id], [code], [parent], [title], [url], [icon], [intro], [preset], [expand], [priority], [deleted], [ctime], [utime]) VALUES (N'10012', N'menu10012', N'-1', N'首页', N'Home', N'el-icon-house', N'首页', N'1', N'0', N'12', N'0', N'2024-04-17 17:52:18.730', N'2024-04-17 17:52:18.730')
GO

SET IDENTITY_INSERT [dbo].[tb_menu] OFF
GO


-- ----------------------------
-- Table structure for tb_prescription
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_prescription]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_prescription]
GO

CREATE TABLE [dbo].[tb_prescription] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [apmt_id] bigint NOT NULL,
  [pt_id] bigint NOT NULL,
  [dr_id] bigint NOT NULL,
  [medicines] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [dosage] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [useway] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [status] int NOT NULL,
  [amount] numeric(8,2) NOT NULL,
  [signature] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_prescription] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'预约id',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'apmt_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'病人id',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'pt_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'医生id',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'dr_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'药物id，逗号分隔',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'medicines'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用量',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'dosage'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用法',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'useway'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'费用',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'amount'
GO

EXEC sp_addextendedproperty
'MS_Description', N'签名链接',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'signature'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription',
'COLUMN', N'utime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'开药信息表',
'SCHEMA', N'dbo',
'TABLE', N'tb_prescription'
GO


-- ----------------------------
-- Records of [tb_prescription]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_prescription] ON
GO

INSERT INTO [dbo].[tb_prescription] ([id], [apmt_id], [pt_id], [dr_id], [medicines], [dosage], [useway], [status], [amount], [signature], [deleted], [ctime], [utime]) VALUES (N'2', N'1', N'1', N'4', N'1,2', N'2,1', N'餐前口服+一日3次+每次两粒,餐前口服+一日2次+每次1支', N'1', N'57.50', N'/res/img/sign/4.jpg', N'0', N'2024-02-26 02:37:21.230', N'2024-02-26 02:37:21.230')
GO

INSERT INTO [dbo].[tb_prescription] ([id], [apmt_id], [pt_id], [dr_id], [medicines], [dosage], [useway], [status], [amount], [signature], [deleted], [ctime], [utime]) VALUES (N'3', N'2', N'1', N'4', N'1,2', N'1,1', N'餐前口服+一日3次+每次两粒,餐前口服+一日2次+每次1支', N'1', N'45.50', N'/res/img/sign/4.jpg', N'0', N'2024-02-26 15:55:51.903', N'2024-02-26 15:55:51.903')
GO

INSERT INTO [dbo].[tb_prescription] ([id], [apmt_id], [pt_id], [dr_id], [medicines], [dosage], [useway], [status], [amount], [signature], [deleted], [ctime], [utime]) VALUES (N'4', N'3', N'1', N'4', N'1', N'1', N'餐前口服+一日3次+每次两粒', N'1', N'12.00', N'/res/img/sign/4.jpg', N'0', N'2024-03-24 23:32:00.443', N'2024-03-24 23:32:00.443')
GO

INSERT INTO [dbo].[tb_prescription] ([id], [apmt_id], [pt_id], [dr_id], [medicines], [dosage], [useway], [status], [amount], [signature], [deleted], [ctime], [utime]) VALUES (N'5', N'4', N'1', N'4', N'2', N'1', N'餐前口服+一日2次+每次1支', N'1', N'33.50', N'/res/img/drSign/2B203AA1-A8BB-457E-3497-11D1D400E729.png', N'0', N'2024-04-15 21:29:23.207', N'2024-04-15 21:29:23.207')
GO

INSERT INTO [dbo].[tb_prescription] ([id], [apmt_id], [pt_id], [dr_id], [medicines], [dosage], [useway], [status], [amount], [signature], [deleted], [ctime], [utime]) VALUES (N'6', N'5', N'1', N'6', N'4', N'1', N'口服+2次/日+每次两粒', N'1', N'40.00', N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-04-19 16:27:27.330', N'2024-04-19 16:27:27.330')
GO

INSERT INTO [dbo].[tb_prescription] ([id], [apmt_id], [pt_id], [dr_id], [medicines], [dosage], [useway], [status], [amount], [signature], [deleted], [ctime], [utime]) VALUES (N'7', N'7', N'1', N'7', N'4', N'1', N'口服+2次/日+每次两粒', N'1', N'40.00', N'/res/img/drSign/145DE9F9-57E4-C1B6-8FBC-C05E09481EA9.png', N'0', N'2024-04-20 09:19:53.577', N'2024-04-20 09:19:53.577')
GO

SET IDENTITY_INSERT [dbo].[tb_prescription] OFF
GO


-- ----------------------------
-- Table structure for tb_rule
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_rule]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_rule]
GO

CREATE TABLE [dbo].[tb_rule] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [code] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [parent] varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [title] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [intro] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_rule] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule',
'COLUMN', N'parent'
GO

EXEC sp_addextendedproperty
'MS_Description', N'组织名称',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule',
'COLUMN', N'title'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule',
'COLUMN', N'intro'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule',
'COLUMN', N'utime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'权限角色表',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule'
GO


-- ----------------------------
-- Records of [tb_rule]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_rule] ON
GO

INSERT INTO [dbo].[tb_rule] ([id], [code], [parent], [title], [intro], [deleted], [ctime], [utime]) VALUES (N'1', N'rule0001', N'-1', N'校医', N'校医角色', N'0', N'2024-01-26 16:23:56.507', N'2024-01-26 16:23:56.507')
GO

INSERT INTO [dbo].[tb_rule] ([id], [code], [parent], [title], [intro], [deleted], [ctime], [utime]) VALUES (N'2', N'rule0002', N'-1', N'学生', N'学生角色', N'0', N'2024-01-26 16:55:13.717', N'2024-01-26 16:55:13.717')
GO

INSERT INTO [dbo].[tb_rule] ([id], [code], [parent], [title], [intro], [deleted], [ctime], [utime]) VALUES (N'3', N'rule0003', N'-1', N'管理员', N'系统操作人员', N'0', N'2024-01-26 17:06:36.210', N'2024-01-26 17:06:36.210')
GO

INSERT INTO [dbo].[tb_rule] ([id], [code], [parent], [title], [intro], [deleted], [ctime], [utime]) VALUES (N'4', N'rule00030004', N'rule0003', N'资讯管理员', N'负责资讯管理', N'0', N'2024-01-26 17:07:31.877', N'2024-01-26 17:07:31.877')
GO

SET IDENTITY_INSERT [dbo].[tb_rule] OFF
GO


-- ----------------------------
-- Table structure for tb_rule_menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_rule_menu]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_rule_menu]
GO

CREATE TABLE [dbo].[tb_rule_menu] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [rule_code] varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [menu_code] varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL
)
GO

ALTER TABLE [dbo].[tb_rule_menu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule_menu',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule_menu',
'COLUMN', N'rule_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule_menu',
'COLUMN', N'menu_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色菜单关联表',
'SCHEMA', N'dbo',
'TABLE', N'tb_rule_menu'
GO


-- ----------------------------
-- Records of [tb_rule_menu]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_rule_menu] ON
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10096', N'rule0001', N'menu10012')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10097', N'rule0001', N'menu10011')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10098', N'rule0001', N'menu0006')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10099', N'rule0001', N'menu00060007')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10100', N'rule0001', N'menu00060008')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10101', N'rule0001', N'menu00060009')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10102', N'rule0001', N'menu0011')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10103', N'rule0001', N'menu0012')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10104', N'rule0002', N'menu10012')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10112', N'rule0003', N'menu10012')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10113', N'rule0003', N'menu0013')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10114', N'rule0003', N'menu0002')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10115', N'rule0003', N'menu0004')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10116', N'rule0003', N'menu0005')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10117', N'rule0003', N'menu0010')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10118', N'rule0003', N'menu0006')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10119', N'rule0003', N'menu00060007')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10120', N'rule0003', N'menu00060008')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10121', N'rule0003', N'menu00060009')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10122', N'rule0003', N'menu0011')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10123', N'rule0003', N'menu0012')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10124', N'rule00030004', N'menu10012')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10125', N'rule00030004', N'menu0006')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10126', N'rule00030004', N'menu00060007')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10127', N'rule00030004', N'menu00060008')
GO

INSERT INTO [dbo].[tb_rule_menu] ([id], [rule_code], [menu_code]) VALUES (N'10128', N'rule00030004', N'menu00060009')
GO

SET IDENTITY_INSERT [dbo].[tb_rule_menu] OFF
GO


-- ----------------------------
-- Table structure for tb_scheduling
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_scheduling]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_scheduling]
GO

CREATE TABLE [dbo].[tb_scheduling] (
  [id] int IDENTITY(1,1) NOT NULL,
  [date] date NULL,
  [stage] int NULL,
  [dr_id] bigint NULL,
  [rest] int NULL,
  [ent_code] varchar(20) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[tb_scheduling] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'排班表id',
'SCHEMA', N'dbo',
'TABLE', N'tb_scheduling',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排班日期',
'SCHEMA', N'dbo',
'TABLE', N'tb_scheduling',
'COLUMN', N'date'
GO

EXEC sp_addextendedproperty
'MS_Description', N'0为全天，1为上午，2为下午',
'SCHEMA', N'dbo',
'TABLE', N'tb_scheduling',
'COLUMN', N'stage'
GO

EXEC sp_addextendedproperty
'MS_Description', N'医师id',
'SCHEMA', N'dbo',
'TABLE', N'tb_scheduling',
'COLUMN', N'dr_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'剩余号源',
'SCHEMA', N'dbo',
'TABLE', N'tb_scheduling',
'COLUMN', N'rest'
GO

EXEC sp_addextendedproperty
'MS_Description', N'机构编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_scheduling',
'COLUMN', N'ent_code'
GO


-- ----------------------------
-- Records of [tb_scheduling]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_scheduling] ON
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'2', N'2024-04-27', N'0', N'4', N'50', N'ent00030004')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'3', N'2024-04-27', N'2', N'5', N'50', N'ent00030004')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'4', N'2024-04-27', N'0', N'6', N'50', N'ent00030005')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'5', N'2024-04-27', N'0', N'7', N'50', N'ent00030006')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'6', N'2024-04-27', N'0', N'8', N'50', N'ent00030007')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'7', N'2024-04-27', N'1', N'9', N'50', N'ent00030008')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'8', N'2024-04-27', N'2', N'10', N'50', N'ent00030008')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'9', N'2024-04-27', N'0', N'11', N'50', N'ent00030009')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'10', N'2024-04-27', N'1', N'12', N'50', N'ent00030010')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'11', N'2024-04-27', N'2', N'13', N'50', N'ent00030010')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'12', N'2024-04-27', N'1', N'14', N'50', N'ent00030011')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'13', N'2024-04-27', N'2', N'15', N'50', N'ent00030011')
GO

INSERT INTO [dbo].[tb_scheduling] ([id], [date], [stage], [dr_id], [rest], [ent_code]) VALUES (N'14', N'2024-04-27', N'0', N'16', N'50', N'ent00030013')
GO

SET IDENTITY_INSERT [dbo].[tb_scheduling] OFF
GO


-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_user]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_user]
GO

CREATE TABLE [dbo].[tb_user] (
  [id] bigint IDENTITY(1,1) NOT NULL,
  [code] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [name] varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [gender] int NULL,
  [birth] date NULL,
  [phone] varchar(11) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [pwd] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [salt] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [open_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [avatar] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [rule_code] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [ent_code] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [ctime] datetime DEFAULT (getdate()) NOT NULL,
  [utime] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[tb_user] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名称',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'性别，1为男，0为女',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'gender'
GO

EXEC sp_addextendedproperty
'MS_Description', N'出生日期',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'birth'
GO

EXEC sp_addextendedproperty
'MS_Description', N'手机账号',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'phone'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'pwd'
GO

EXEC sp_addextendedproperty
'MS_Description', N'加密盐值',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'salt'
GO

EXEC sp_addextendedproperty
'MS_Description', N'微信小程序登录id',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'open_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'头像链接',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'avatar'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'rule_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单位编码',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'ent_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识符',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'ctime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'utime'
GO


-- ----------------------------
-- Records of [tb_user]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_user] ON
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'1', N'stu202008764230', N'彭郁钧', N'1', N'2001-06-23', N'13416393834', N'76b00afec58f7737f1ff366be78b1c27', N'bUawEC', N'oAwmB5aSj1bMcXD-r2W7cqtzVGCs', N'/res/img/avatar/1.jpg', N'rule0002', N'ent0014001500160018', N'0', N'2024-01-25 14:46:42.073', N'2024-01-25 14:46:42.073')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'3', N'dr0003', N'王泰斯', N'1', N'1990-06-22', N'13535318706', N'9e20981d16934f77ef0c2aa97c27fdda', N'5xyu4m', N'', N'/res/img/avatar/3.jpg', N'rule0001', N'ent00030004', N'0', N'2024-02-23 00:23:18.120', N'2024-02-23 00:23:18.120')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'4', N'dr0004', N'杨阳', N'1', N'1983-05-02', N'14538783820', N'ce3da80670f9dce4b5637e1622e448a0', N'bO6I8O', N'oAwmB5aSj1bMcXD-r2W7cqtzVGC1', N'/res/img/avatar/4.jpg', N'rule0001', N'ent00030004', N'0', N'2024-02-24 00:33:14.463', N'2024-02-24 00:33:14.463')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'5', N'dr0005', N'张绍文', N'1', N'1988-03-31', N'17683484143', N'5171304e1a2f209ddfd66d252be28a78', N'6vKDrQ', NULL, N'/res/img/avatar/5.jpg', N'rule0001', N'ent00030004', N'0', N'2024-02-24 00:35:59.257', N'2024-02-24 00:35:59.257')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'6', N'dr0006', N'倪群', N'0', N'1998-12-31', N'14606013829', N'ffd61164179a1717496a1197826ce15c', N'TT7GCV', N'oAwmB5aSj1bMcXD-r2W7cqtzVGC1', N'/res/img/avatar/6.jpg', N'rule0001', N'ent00030005', N'0', N'2024-02-24 00:40:00.760', N'2024-02-24 00:40:00.760')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'7', N'dr0007', N'黄宜', N'1', N'1988-10-01', N'15277212611', N'979499ce8b77ba53098c5e63631d4eda', N'Zz2HVy', NULL, N'/res/img/avatar/7.jpg', N'rule0001', N'ent00030006', N'0', N'2024-02-24 00:40:46.610', N'2024-02-24 00:40:46.610')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'8', N'dr0008', N'詹晓玲', N'0', N'1999-10-09', N'13044241475', N'fcaa1e1a662f9dd8485108bd972a7331', N'21KOl7', NULL, N'/res/img/avatar/8.jpg', N'rule0001', N'ent00030007', N'0', N'2024-02-24 00:41:27.007', N'2024-02-24 00:41:27.007')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'9', N'dr0009', N'沈建庆', N'1', N'1992-08-18', N'15500976461', N'b94c253be63a28838b2e5372d76541ad', N'kppr4t', NULL, N'/res/img/avatar/9.jpg', N'rule0001', N'ent00030008', N'0', N'2024-02-24 00:42:04.423', N'2024-02-24 00:42:04.423')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'10', N'dr0010', N'郑海涛', N'1', N'1993-09-06', N'18623675937', N'cfa1e3d105011939a5657f9a09d52661', N'yFO4Rw', NULL, N'/res/img/avatar/10.jpg', N'rule0001', N'ent00030008', N'0', N'2024-02-24 00:42:47.073', N'2024-02-24 00:42:47.073')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'11', N'dr0011', N'陈立峰', N'1', N'1979-12-24', N'17763089961', N'5724a324b49a5ef0f8db21f20aff7ff1', N'CgP4J1', NULL, N'/res/img/avatar/11.jpg', N'rule0001', N'ent00030009', N'0', N'2024-02-24 00:43:52.507', N'2024-02-24 00:43:52.507')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'12', N'dr0012', N'萧旒萍', N'0', N'1987-07-11', N'17249383579', N'457edc96fd263d136efb2b3383c14b61', N'mKoZcl', NULL, N'/res/img/avatar/12.jpg', N'rule0001', N'ent00030010', N'0', N'2024-02-24 00:44:47.480', N'2024-02-24 00:44:47.483')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'13', N'dr0013', N'竺远', N'0', N'1995-10-28', N'13899237201', N'0e71950b0e2093b224a8873854ec986a', N'dwaPqR', NULL, N'/res/img/avatar/13.jpg', N'rule0001', N'ent00030010', N'0', N'2024-02-24 00:45:45.040', N'2024-02-24 00:45:45.040')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'14', N'dr0014', N'肖瑾言', N'0', N'1992-09-24', N'15178423861', N'bdb6da86f2c4ec7c620d863f935b8316', N'C2kx9p', NULL, N'/res/img/avatar/14.jpg', N'rule0001', N'ent00030011', N'0', N'2024-02-24 00:46:24.653', N'2024-02-24 00:46:24.653')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'15', N'dr0015', N'胡苗', N'0', N'1982-12-10', N'13192357695', N'2ae67ee7d1ea17aa4993cad7f927a1b7', N'V5CGqX', NULL, N'/res/img/avatar/15.jpg', N'rule0001', N'ent00030011', N'0', N'2024-02-24 00:47:04.720', N'2024-02-24 00:47:04.720')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'16', N'dr0016', N'张迎春', N'1', N'1994-10-16', N'13554126220', N'e5ed237c9e930d7c13ec667d62b7bcac', N'rqAC00', NULL, N'/res/img/avatar/16.jpg', N'rule0001', N'ent00030013', N'0', N'2024-02-24 00:47:39.097', N'2024-02-24 00:47:39.097')
GO

INSERT INTO [dbo].[tb_user] ([id], [code], [name], [gender], [birth], [phone], [pwd], [salt], [open_id], [avatar], [rule_code], [ent_code], [deleted], [ctime], [utime]) VALUES (N'17', N'manage0001', N'王管管', N'1', N'1991-03-31', N'15363176887', N'3d647d72bb24edcd3921d058b69e83bc', N'uFNrxi', NULL, N'/res/img/avatar/17.jpg', N'rule0003', N'ent0021', N'0', N'2024-04-17 19:08:13.413', N'2024-04-17 19:08:13.413')
GO

SET IDENTITY_INSERT [dbo].[tb_user] OFF
GO


-- ----------------------------
-- Primary Key structure for table tb_appointment
-- ----------------------------
ALTER TABLE [dbo].[tb_appointment] ADD CONSTRAINT [PK__tb_appoi__3213E83F7275B4E0] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_chat
-- ----------------------------
ALTER TABLE [dbo].[tb_chat] ADD CONSTRAINT [PK__tb_chat__3213E83F77A80122] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_config
-- ----------------------------
ALTER TABLE [dbo].[tb_config] ADD CONSTRAINT [PK__tb_confi__3213E83F43030670] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_diagnosis
-- ----------------------------
ALTER TABLE [dbo].[tb_diagnosis] ADD CONSTRAINT [PK__tb_diagn__3213E83F45A97066] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_disease
-- ----------------------------
ALTER TABLE [dbo].[tb_disease] ADD CONSTRAINT [PK__tb_disea__3213E83F2B289859] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_doctor
-- ----------------------------
ALTER TABLE [dbo].[tb_doctor] ADD CONSTRAINT [PK__tb_docto__3213E83FF35E651C] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_enterprise
-- ----------------------------
ALTER TABLE [dbo].[tb_enterprise] ADD CONSTRAINT [PK__tb_enter__3213E83F5592A23D] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_essay
-- ----------------------------
ALTER TABLE [dbo].[tb_essay] ADD CONSTRAINT [PK__tb_essay__3213E83FAF445016] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_essay_type
-- ----------------------------
ALTER TABLE [dbo].[tb_essay_type] ADD CONSTRAINT [PK__tb_essay__3213E83FC009D6CB] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_medicine
-- ----------------------------
ALTER TABLE [dbo].[tb_medicine] ADD CONSTRAINT [PK__tb_medic__3213E83F332326E7] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_menu
-- ----------------------------
ALTER TABLE [dbo].[tb_menu] ADD CONSTRAINT [PK__tb_menu__3213E83F235CC30A] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_prescription
-- ----------------------------
ALTER TABLE [dbo].[tb_prescription] ADD CONSTRAINT [PK__tb_presc__3213E83F116AC95F] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_rule
-- ----------------------------
ALTER TABLE [dbo].[tb_rule] ADD CONSTRAINT [PK__tb_rule__3213E83FD2B9739C] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_rule_menu
-- ----------------------------
ALTER TABLE [dbo].[tb_rule_menu] ADD CONSTRAINT [PK__tb_rule___3213E83FF9165BCE] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_scheduling
-- ----------------------------
ALTER TABLE [dbo].[tb_scheduling] ADD CONSTRAINT [PK__tb_sched__3213E83F588E11DE] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tb_user
-- ----------------------------
ALTER TABLE [dbo].[tb_user] ADD CONSTRAINT [PK__tb_user__3213E83FF95FD9B3] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO

